package com.scfinance.SPD.dao;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.text.SimpleDateFormat;
import java.util.*;

/**
 * Created by admin on 2017/6/28.
 */
@Repository
public class testDaoImpl {
   @Autowired
   private JdbcTemplate jdbcTemplate;

   private Logger logger = LoggerFactory.getLogger(testDaoImpl.class);

   public List<Map<String, Object>> testFind(){
      Object[] paramsObj = {"8a9b870e5b6682e1015b8017fa1100a5", "hudi","0000", "test", "123123"};
      String sql = "INSERT INTO SPDOutput (\n" +
              "\torderId,\n" +
              "\tcustomerName,\n" +
              "\tuploadCode,\n" +
              "\tuploadMsg,\n" +
              "\tSPDappId,\n" +
              "\tcreate_time,\n" +
              "\tupdate_time\n" +
              ")\n" +
              "VALUES\n" +
              "\t(?,?,?,?,?, NOW(), NOW())";
      jdbcTemplate.update(sql, paramsObj);
       return null;
   }

}
